Returns the average of the absolute deviations of data points from their mean. AVEDEV is a measure of the variability in a data set.
Syntax
AVEDEV(number1,number2, ...)
Number1, number2, ... are 1 to 30 arguments for which you want the average of the absolute deviations. You can also use a single array or a reference to an array instead of arguments separated by commas.
Remarks
AVEDEV is influenced by the unit of measurement in the input data.
Example
The example may be easier to understand if you copy it to a blank spreadsheet.
Selecting an example from Help
Data | |
---|---|
4 | |
5 | |
6 | |
7 | |
5 | |
4 | |
3 | |
Formula | Description (Result) |
=AVEDEV(A2:A8) | Average of the absolute deviations of the numbers above from their mean (1.020408) |